Efficiency evaluation of data warehouse operations

نویسندگان

  • Michael V. Mannino
  • Sa Neung Hong
  • Injun Choi
چکیده

We present an efficiency model for data warehouse operations and analyze a data set to evaluate the model. The model contains salient variables to evaluate the efficiency of an organization’s data warehouse operations for refresh processing and query production. The variables in the model include resource consumption (labor usage and computing budgets), system usage measures (users and queries), quality measures (data age and availability), and a size measure (change data amount). We report on the evaluation of a data set collected from USA and non USA-based (mostly Korean) organizations using input-oriented Data Envelopment Analysis. The analysis indicates wide dispersions in reported data, large differences in labor budgets between efficient and inefficient firms, few organizations efficient in both refresh processing and query production, and the difficulty of providing some data (computing budgets and flexibility ratio). Follow-up interviews with selected organizations provided insights about the value of efficiency comparisons of information technology organizations and suggestions to improve the model.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Doctor of Philosophy in Computer Science and Information Systems Working Paper CSIS 2004-003 Efficiency Models for Data Warehouse Operations

We present efficiency models to evaluate data warehouse operations and analyze a preliminary data set using one of the models. The macro model represents the efficiency of operating a collection of data warehouses for both refresh processing and query production over a monthly horizon. The micro models represent the efficiency of daily operations an individual data warehouse for either refresh ...

متن کامل

Utility of Ranking Warehouse Candidates in Workshop Locations Using UTAStar

Although the importance of locating in manufacturing and service companies is not a new issue, one of significance applications is to determine the appropriate location for warehouses in manufacturing workshops warehouses to the maintenance of materials or products. In any organizations, Finding the suitable site for warehouses establishments to increase customer service and efficiency is one o...

متن کامل

Improvement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation

A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...

متن کامل

Performance Measurement in the Warehousing Industry

Warehouses are a substantial component of logistic operations, and an important contributor to speed and cost in supply chains. While there are widely accepted benchmarks for individual warehouse functions like order picking, little is known about the overall technical efficiency of warehouses. Lacking a general understanding of warehouse technical efficiency and the associated causal factors l...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • Decision Support Systems

دوره 44  شماره 

صفحات  -

تاریخ انتشار 2008